--*-----------------------------------------------------------------------------
--
-- SetOptionText
--
--*-----------------------------------------------------------------------------
IF EXISTS (
  SELECT 1 FROM sys.objects
   WHERE type = 'P'
     AND schema_id = SCHEMA_ID('dbo')
     AND name = 'SetOptionText'
)
DROP PROCEDURE SetOptionText
GO
--*-----------------------------------------------------------------------------
CREATE PROCEDURE SetOptionText(@key_str VARCHAR(50), @value_text NVARCHAR(MAX))
AS
BEGIN
  UPDATE site_option
     SET value_text = @value_text
   WHERE name = @key_str
END
GO